05 链接配置

配置文件说明

Oracle数据库的链接配置文件目录位于： %ORACLE_HOME%\product\11.2.0\dbhome_1\NETWORK\ADMIN

文件说明：

listener.ora 是服务端的 “入口配置”，决定数据库如何对外提供连接服务；
tnsnames.ora 是客户端的 “地址簿”，让客户端能通过别名快速定位数据库；
sqlnet.ora 是两端的 “连接规则”，定义连接的认证、超时等通用网络属性。

listener.ora

# listener.ora Network Configuration File: \Oracle\ORCL11G\product\11.2.0\dbhome_1\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-27DN7DK)(PORT = 1521))
  )
  
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)  # 与数据库的SERVICE_NAME一致
      (SID_NAME = ORCL)      # 与数据库实例名一致
      (ORACLE_HOME = T:\Oracle\ORCL11G)
    )
  )

ADR_BASE_LISTENER = T:\Oracle\ORCL11G\product\11.2.0\dbhome_1\log

tnsnames.ora

LISTENER_ORCL = 
	(ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1521))

LOCAL=
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = FREE)
    )
)

ORCL=
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = ORCL)
    )
)

sqlnet.ora

# sqlnet.ora Network Configuration File: D:\Develop\instant\instantclient_23_9\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = T:\Oracle\ORCL11G